/* THIS QUERY WILL RETURN A LIST OF TABLES IN THE DATABASE, AND HOW MANY ROWS ARE PRESENT */

SELECT		CONVERT(varchar(50), OBJECT_NAME(id)) As 'Table Name',
			ROWS AS 'Records'
FROM		[sysindexes]
WHERE		OBJECT_NAME(id) NOT LIKE 'sys%' AND [indid] = 1
AND			ROWS > 0
ORDER BY	OBJECT_NAME(id)

SELECT		SUM(ROWS) AS 'Records'
FROM		[sysindexes]
WHERE		OBJECT_NAME(id) NOT LIKE 'sys%' AND [indid] = 1